Jim Hook ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	27

About Me

About Me

Area of Expertise	Web Forms
About Me	With a background in electronics, computer science and semiconductor testing I missed the technical involvement after 11 years of retirement and ended up helping out at Breyta in a number of roles as the company has grown quickly over the last three years.
How I Use Smartsheet	I provide project timekeeping and financial analysis for a small company with Fortune 500 clients located mainly in the US and Europe. With Smartsheet I keep realtime track of the 40+ projects underway at any point in time and provide feedback to managers and supervisors that continually helps them to improve estimating and project execution processes.

Analytics

258

Posts

66

Visits

1.7k

Points

Apr 6, 2015

Join Date

Jan 17, 2024

Last Active

Reactions

• Insightful 6

  6
• Vote Up 11

  11
• Awesome 2

  2

• Activity
• Discussions27
• Comments231

• Re: Link Separate Smartsheets into a 'super sheet'

  Jim Hook

  10/28/15
  Yes you can. Smartsheet's linking capabilities are much advanced compared to Excel or Google sheets. Here's how to do it: 1. On your summary sheet, drag your mouse over all the cells you want to link…
  3 ·

• Re: Combine IF formulas in one cell

  Jim Hook

  02/06/18
  Hi Phil, I'm not 100% sure I understand what you're trying to do but my first thought is that you can use a nested IF() function to combine multiple IF() formulas into one. The general idea of a nest…
  1 ·